<?php
/**
 * Copyright (c) 2010, Slawomir Mazur <mazursllawek@gmail.com>
 * 
 * All rights reserved.
 * 
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions 
 * are met:
 * 
 * o Redistributions of source code must retain the above copyright notice, 
 *   this list of conditions and the following disclaimer.
 * o Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation
 *   and/or other materials provided with the distribution.
 * o Neither the name of the Softisland nor the names of its contributors
 *   may be used to endorse or promote products derived from this software
 *   without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 
 * HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
/**
 * Enter description here...
 *
 * @package     System
 * @copyright   Slawomir Mazur (c) 2010 (http://www.zend.com/zce.php?c=ZEND011643)
 * @license     http://www.opensource.org/licenses/bsd-license.php
 * @author      Slawomir Mazur <mazursllawek@gmail.com>
 */

class System_Model_Company extends Zend_Db_Table_Abstract
{
	protected $_name = 'company';
	
	protected $_primary = 'company_id';
	
	protected $_collection = null;
	
	public function getCollection()
	{
		$select = $this->select()->order('name');
		
		return $this->fetchAll($select);
	}
	
	public function getCompanyById($id)
	{
		$id = (int) $id;
		$result = $this->find($id);
		
		if (!$result->count()) {
			throw new Exception('Company with the given id doesn\'t exists');
		}
		return $result->current();
	}
	
	public function getCompanyByLibraryId($id)
	{
		$id = (int) $id;
		
		$select = $this->select()
				->setIntegrityCheck(false)
				->from(array('c' => $this->_name), array('cname' => 'name'))
				->join(array('l' => 'library'), 'c.company_id = l.company_id')
				->where('library_id = ?', $id)
				->limit(1);

		$company = $this->fetchRow($select);
		
		if (empty($company)) {
			return '';
		}
		return $company;
	}
	
	public function getCompanyIdByLibraryId($id)
	{
		if ($company = $this->getCompanyByLibraryId($id)) {
			return $company->company_id;
		}
		return '';
	}
	
	public function getCompanyNameByLibraryId($id)
	{
		if ($company = $this->getCompanyByLibraryId($id)) {
			return $company->cname;
		}
		return '';
	}
}